Tabela ServiceComponent

Definicja tabeli ServiceComponent

Name

ServiceComponent

Code

ServiceComponent

Comment

Skladnik uslugi - umozliwia zdefiniowanie, które koszty (posrednie i bezposrednie) beda wliczane do kosztu rzeczywistego uslugi w czasie podzialu kosztów


Lista kolumn tabeli ServiceComponent

Name

Code

ServiceComponentID

ServiceComponentID

FullName

FullName

Active

Active

Independent

Independent


Kolumna ServiceComponentID tabeli ServiceComponent

Definicja kolumny ServiceComponentID tabeli ServiceComponent

Name

ServiceComponentID

Code

ServiceComponentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FullName tabeli ServiceComponent

Definicja kolumny FullName tabeli ServiceComponent

Name

FullName

Code

FullName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Active tabeli ServiceComponent

Definicja kolumny Active tabeli ServiceComponent

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Independent tabeli ServiceComponent

Definicja kolumny Independent tabeli ServiceComponent

Name

Independent

Code

Independent

Data Type

NUMBER(5)

Mandatory

No

Comment

Oznacza czy koszty rzeczywiste liczyc niezaleznie od innych uslug


Lista kluczy tabeli ServiceComponent

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ServiceComponent

Definicja klucza Identifier_1 tabeli ServiceComponent

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment